Release 10.1A: OpenEdge Data Management:
SQL Reference


SYSTABLES

Contains one row for each table in the database.

Table 5 provides details of the SYSTABLES table.

Table 5: SYSTABLES core system table 
Column name
Column data type
Column size
creator
VARCHAR
32
has_ccnstrs
VARCHAR
1
has_fcnstrs
VARCHAR
1
has_pcnstrs
VARCHAR
1
has_ucnstrs
VARCHAR
1
id
INTEGER
4
owner
VARCHAR
32
rssid
INTEGER
4
segid
INTEGER
4
tbl
VARCHAR
32
tbl_status
VARCHAR
1
tbltype
VARCHAR
1


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095